<?php
`git config --global user.name "杨冰雨"`;
`git config --global user.email "1348984151@qq.com"`;
`net start mysql`;


$db=new PDO('mysql:host=localhost','root','12qwas');
$db->exec("create database if not exists db");
$db->exec("use db");
$db->exec("drop table if exists students");
$db->exec("create table if not exists students(xh varchar(9) primary key not null, pwd varchar(20) not null default '123456', name varchar(50) not null, tel char(11) not null)");
$r=$db->exec("truncate table students");
var_dump($r);
$r=$db->exec("insert into students(xh,name,tel) values('233110101','张三','13333333333'),('233110102','李四','13444444444'),('233110103','王五','13555555555')");
echo "成功插入了{$r}条记录~\n";
$r=$db->exec("update students set name='张三丰' where xh='233110101'");
echo "成功修改了{$r}条记录~\n";